package com.qf.mapper;

import com.qf.pojo.DevUser;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import tk.mybatis.mapper.common.Mapper;

public interface DevUserMapper extends Mapper<DevUser> {
    @Select("select count(1) from dev_user where dev_username=#{devUsername}")
    Integer checkUsername(@Param("devUsername") String username);
    @Delete("delete from dev_user where created < now() - interval 3 day and dev_state = #{state}")
    Integer deleteBy3Day(@Param("state")Integer state);
}
